#ifndef EXCEL_H
#define EXCEL_H

#include <QWidget>
#include <QSqlQuery>
#include <QAxObject>
#include <QDebug>


namespace Ui {
class Excel;
}

class Excel : public QWidget
{
    Q_OBJECT

public:
    explicit Excel(QWidget *parent = nullptr);
    ~Excel();

    void InitExcel();
    void clearSQL();
    void LinkSQL();

private:
    Ui::Excel *ui;
    void showTableString(const QStringList table);
    void connectAllSignals();
    void ClearSql();
    QSqlDatabase db;
    QAxObject* myExcel;

public slots:
    void OpenExcel();
    void SaveExcel();
    void OpenSQL();
    void ToSQL();
};

#endif // EXCEL_H
